May 28 2018

Worlwide statistics for air quality

1 in every 8 deaths is result of exposure to contaminated air WHO, 2012

Air pollution is the single biggest environmental killer, claiming 6.5 million lives each year UN, 2017

Source: EPI Index 2016

Motivation

Enviromental Authorities

Academia

Data

Analytics capability

Technical know-how

Software skills

Current situation and objetives

In colombia

  • Air quality is a priority for local governments
  • High impact on population and resonance on media
  • Limited budget and technical capacity of local authorities
  • The academia ought to contribute

Our purpose: simplify and automate

  • Define repeatable and flexible data analyses
  • Develop tools for automating processes
  • Relay on open source

Application case: Bogotá

  • Data Source: RMCAB 1998-2016
    • PM10 and PM2.5
  • Data cleaning based on rules

  • Implementation with R
    • Web based
    • Intuitive Visualizations
  • aire.shinyapps.io/airqualitytool/

Methodology

Data cleaning

Data Availability

Descriptive analysis - Time series

Comparative analysis

Evaluation of carr free day enviromental policy (\(PM_{2.5}\))

User definable analysis

Comparison Fridays, Saturdays and Sundays (\(PM_{2.5}\))

Environmental indicator analysis

AQI

Classification \(PM_{2.5}\) \(PM_{10}\) Color
Good 0 - 12 0 - 54 Green
Moderate 13 - 36 55 - 154 Yellow
Harmful for sensible people 37 - 56 155 - 254 Orange
Harmful for general public 57 - 151 255 - 354 Red
Very harmful 152 - 251 355 - 424 Purple
Dangerous 252 - 501 425 - 604 Brown

Environmental indicator analysis

\(PM_{2.5}\)

Environmental indicator analysis

\(PM_{10}\)

Daily profile

Conclusions

aiRe

  • Web-based open source software to perform analysis of air quality

  • Easy to extend functionalities

  • Validated by academic experts

  • Source Code https://github.com/jj-diaz1067/aiRe

Validation

  • Accompaniment of ministry of environment
  • Presented to most environmental agencies in Colombia

Presentations

Congresses

  • 2nd Colombian congress for operational research, ASOCIO 2017
  • 23th International sustainable development society, ISDRS 2017
  • VI Colombian congress and international conference of air quality and public health, CASAP 2017

Other presentations

  • Analytics Forum 2017
  • Master's of Science in Analytics
  • COPA

Future Work

Public collaboration

  • Joint work with the Colombian Ministry of Environment
    • Deployment to all environmental authorities in the country
  • Support local district environment authorities
    • Understand analytical needs, and accordingly extend the software

Increase application functionality and usefulness

  • Implement spacial analysis (Rojas, 2017)
  • Real-time navigation and warnings (BogoAir, 2017)
  • Decision support tool for comparative analysis (Díaz, 2017)
  • Predictive models for issuing early warnings
  • Estimating citizenship exposure
  • Health impacts

Acknowledgement

Thesis advisor Ivan Mura

Advisor Juan Felipe Franco

COPA

Industrial Engineering Department

Faculty of Engineering

Thank you!